Entry Name: "UK-Meschenmoser-MC2"
VAST
Challenge 2016
Mini-Challenge 2
Team Members:
Philipp Meschenmoser, University of Konstanz, Germany, philipp.meschenmoser@uni-konstanz.de PRIMARY
Rita Sevastjanova, University of Konstanz, Germany, rita.sevastjanova@uni-konstanz.de
Phi-Vu Ly, University of Konstanz, Germany, phi.ly@uni-konstanz.de
Student Team: YES
Tools Used:
Tableau
Custodia, developed by the University of Konstanz Applied Visual Analytics course, taught Spring 2016 by Prof. Dr. D. A. Keim, and adapted by the student team for the challenge.
Approximately how
many hours were spent working on this submission in total?
120 hours.
May we post your
submission in the Visual Analytics Benchmark Repository after VAST Challenge
2016 is complete? YES
Video
MP4: https://1drv.ms/v/s!ArD90eeKQ0KRjlc9Jep12Vuhoz9V
WMV: https://1drv.ms/v/s!ArD90eeKQ0KRjmbsHNktvS8CoW7I
"Custodia" is a security-oriented application for detecting and comparing global as well as local movement patterns and relations between energetic sensors. It relates to interlinked visualizations, whereas the data foundation was provided by this year's VAST Challenge.
The choro visualization aims at displaying patterns and anomalies of static proximity card data for employees. For that purpose we subdivide the design space into 3 sections, representing the different floors of the building. Each of the section is divided into equal-sized subitems, providing the information about hourly windows within the two weeks. Within those we color-encode the frequency of recorded proximity cards in the respective zones. The domain of recorded instances can be reduced by applying filters for institutional-departments. By selecting a single proximity polygon, the employees being active can be displayed.
As we identified spatial precision increasingly relevant with respect to mobile proximity data, we reference the latter in a more detailed and precise interface. There the frequency of the recorded proximity cards is mapped to the size and transparency of the dots. In addition, we provide further filter opportunities and navigational patterns.
We achieve the linkage between positional and energetic data, by displaying the latter in a visually comparable UI. Using a circular glyph layout we ilustrate the variances of the energetic sensor data between intervals of 5 minutes. The glyphs are divided into four specifically colored groups, representing the temperature, air flow, energy consumption and remaining information, like CO2 concentration and damper settings.
To gain an overview for the entire temporal range, we provide a spiral-view visualization. One spiral ilustrates data either for one energy zone, floor or the whole building on a specific day. The temporal domain of 24 hours is encoded onto the circle segments radii, using binnings of 5 minutes. The spirals are arranged according to topological and temporal aspects.
After having conducted few data transformation and preprocessing steps, we were able to integrate each (i.e. movement, energetic and miscellaneous) type of data into our system of
linked and complementing visualizations. Our visualization layer can be subdivided by naming two categories. We relate to views which provide an overview for the entire temporal range, aiming
to the detection of global patterns. Thus, we observed tabularised choropleths and our spiral glyph visualization as well apllicable approaches. In addition, we provide visualizations where we
set our focus rather on spatial and temporal precision. By combining both visualization types,local patterns and anomalies can be well detected- especially at the overview- and analyzed
- especially on the focus level. Regarding our interaction layer, we integrated rich filtering opportunities, by which comparisons between settings can be conducted. Furthermore,
details-on-demand approaches are included, as various information (concrete sensor measurements, accumulations of positional information, etc.) gets displayed by clicking or hovering elements.
Questions
MC2.1 – What are
the typical patterns visible in the prox card
data? What does a typical day look like for GAStech employees?
Limit your response to no more than 6 images and
500 words.
1. The normal working day (Monday-Friday) begins at 7AM and lasts till 5PM.
2. Shortly before 12PM employees start to leave the building (lunch time), and after 12PM they are returning to their offices again. The flow of staff members indicates to it - on the floor 1 no offices are located, therefore increased level of prox records on floor 1 could mean that employees are entering or leaving the building.
3. In the evenings some staff members are still working. (facilities, IT, G. Florez from administration (7.Juni 0AM), engineering).
4.Meetings of Engineering and IT Department between 2PM and 3PM around 2700 (lot of distinct employees having a significant distance to their common offices).
MC2.2 – Describe up
to ten of the most interesting patterns you observe in the building data. Describe
what is notable about the pattern and explain what you can about the
significance of the pattern.
Limit your response to no more than 10 images and
1000 words.
1. Such timestamps exist, where on the floor 1 and 2 almost all floor sensors have 0 values (except inlet and outlet temperature). In the energy zones the SUPPLY INLET Mass Flow Rate is 0. SUPPLY INLET Temperature is the same as VAV-SYS SUPPLY Outlet Temperature on the respective floor. It happens during the night and weekends. Could it mean that the system has some issues to be solved?
2. On the floor 1 and 2 - if the Thermostat Setpoints are changed (at 6AM), then one hour till 7AM for the BathExhaust: Fan Power, VAV SYS Outdoor Air Flow Fraction, VAV SYS Outdoor Air Mass Flow Rate (floor sensors) the values are 0. It also might indicate to problems existing in the VAV system.
3. Nobody visits left-sided wing of offices on second floor after 5PM.
4. No one from facility department visits left-sided wing on second floor within the two weeks. Exception: P. Young (10 AM bin, on 2 subsequent days) and C. Hawelon (every day on 3PM bin).
5. Averaged Movement Pattern Rosie:
1;"09:00:00" - "09:04:13"
2;"09:07:42" - "09:30:00"
3; "09:32:30" - "9:46:18"
Good-bye on floor 1: "09:54:46"
1; "14:00:00" - "14:04:20"
2; "14:08:06" - "14:26:30"
3; "14:33:30" - "14:46:12"
Good-bye on floor 1: 14:54:00
We observed first and last Rosie recordings We identified first and last movement detections from Rosie per floor and time-unit and averaged over 14 days.
6. Employees from Security Department have their central in 2710. Exceptional movement patterns occur with respect to the following employees: fresumir001 is the only one patroling on floor3. S. Fusil and V. Lagos are active in entry area (corridors and gates). In the morning, we expect a meetup for the security department in 2710.
7. Thermostat Heating Setpoints and Thermostat Cooling Setpoints differ for the day and night. The 'normal' settings (settings for the most of the days in most of the zones) for the day (6AM-22PM) Setpoints are approx. 21-24 degrees and in the night (22PM-6AM) approx. 16-26.
8. The daily energy consumption for most of the zones is quite similar. The energy is used at similar points of time and having similar duration.
9. In corridors lights are always switched on, even during night and weekends.
10. In Zone 9 (server) on the floor 3 the Thermostat Setpoints stays the same (except in the two days when the Setpoints of the whole building (except the Zone 1 on Floor 3) are set higher), very high energy consumption.
MC2.3 – Describe up to ten notable anomalies or unusual
events you see in the data. Describe when and where the event or anomaly occurs
and describe why it is notable. If you have more than ten anomalies to report,
prioritize those anomalies that are most likely to represent a danger or
serious issue for building operation.
Limit your response to no more than 10 images and
1000 words.
1. The first time, when the Thermostat Setpoints are changed to much higher values as usual, it happens on the floor 1, floor 2 and on the floor 3 (on the 1st of June at 1:05PM). On the floor 3 increases the Hazium value (beginning at 1:15PM). Although, one could assume, that the Setpoints might influence the changes of the Hazium value, why doesn't it happen on the floor 1 and 2 too then?! Maybe the correlation between Setpoints and the increase of Hazium value in this case is just by an accident?
2. On the 2nd of June in the zone 1 on floor 3 Hazium is still in the air. The Thermostat Setpoints are set to 10 degrees, which means that the Damper is opened, the Supply Inlet Mass Flow Rate is increased and the air circulation is provided. Beginning with that point of time the Hazium concentration on the floor 2 starts to increase. In the beginning of the work day after the Dampers on the floor 2 are opened, the value of the Hazium increases even more.
Shortly after 1PM on the floor 3 in zone 1 the Setpoints are set much higher again, which means that the Dampers are closed, Reheat Coil Power increases. That means, that no air circulation is provided, the value of Hazium in this zone increases. Interesting is that such kind of pattern (very low and very high Thermostat Settings for the zone 1 on floor 3) remains for the rest of the 13 days.
3. In the whole building on the 7th and 8th of June (Wednesday and Thursday), all the Setpoits are set really high (even in the Server zone, where the settings have never been changed) during day and low during night. Only the zone 1 on floor 3 remains with its specific settings. Could it mean that the zone 1 on floor 3 is some specific zone, where some restrictions exist - maybe one is not able to change settings for the whole building including the zone 1?
4. On the weekends some employees (Administration: lcarrara001, mbramar001, llagos001) are taking the elevator to the floor 3 and visiting diverse zones (including the zone 1 where the Hazium Sensor is located).
5. On the floor 2 where 2 Hazium sensors are located, both of the sensors have similar values in the same points of time. That might mean, that the Hazium is distributed with the Air Supply System.
6. Missing proximity data/cards per department: Security 10/21 (47.6%) , Admins 1/15 (6.6%), Engineering 1/34(2.9%), Executive 3/10(33.3%), IT 1/18 (5.5%), Facilities 3/24 (12.5%), HR 0/3. We found this out after simply querying our database. Probably the security members are leaving their cards on the floor 2 and walking around without any prox card.
7. On the floor 1 in zone 2: two times the Setpoints are being changed to much higher temperature (only in this single zone). It happens on the 1st of June (Wednesday) and on the 10th of June (Friday). Strange is the fact, that in that zone no specific energy or lights power consumption is visible (which could mean, that no one is working in this zone). Why to change the Setpoints then?
8. Only two mobile prox records for administrators on second floor, concentrated on third floor. Similar for Executive Department- and only one registered security there?
9. Geneviere Florez (Administration) possesses the most prox cards (common:1-2, she: gflorez00[2,5]). We found this out after simply querying our database. What's about gflorez001? Maybe lost?
10. On the floor 3 in Zone 1 there is not a similar daily energy usage. The time and duration changes for different days.
MC2.4 –– Describe up to
five observed relationships between the proximity card data and building data
elements. If you find a causal relationship (for example, a building event or
condition leading to personnel behavior changes or personnel activity leading
to building operations changes), describe
your discovered cause and effect, the evidence you found to support it, and
your level of confidence in your assessment of the relationship.
Limit your response to no more than 10 images and
1000 words.
1. On the 11th of June (Saturday) O.Strum(001)-Executive, M.Bramar(001)-Administration are on the floor 3 in the zone 2 and 8. Afterwards the Hazium value increases in the whole building. Suspicious is that the settings of the VAV system are specific for the weekend/Sunday (constant settings for all 24 hours, system actually might relax). Is one of the staff members the reason for increased level of Hazium?
2. On the weekends some staff members (L.Carrara(001)-Administration, O.Strum(001)-Executive, M.Bramar(001)-Administration, L.Lagos(001)-Administration) are in the zone 1, but no energy or lights power is used. Do they want to stay unrecognized?
3. On the 9th of June (Thursday) on Floor 3 all Setpoints are changed to very low temperature, only in zone 8 the settings are changed to high temperature which means, that the dampers are closed. In this zone might be the I.Lagos(001), P.Beebe(001), P.Young(002)
4. When the first time on the floor 3 in zone 1 the Thermostat Setpoints are changed (7AM), 4 persons are recorded in the zone: L.Carrara(001)-Administration, , M.Bramar(001)-Administration, L.Lagos(001)-Administration, L.Fresumir(001)-Security. At 3PM when the Setpoints are set much higher, no person is recorded in this zone. It might indicate, that at 7AM already the settings for the following time-period (following 13 days) have been set.
5. Shortly before the Hazium value increases on the floor 3 (on the 1st of June), in two other zones (5 and 6) are changed the Thermostat Setpoints. No prox cards are recorded in these zones at this point of time. But following persons are registered in the corridor: C.Lair, C.Solos, M.Bramar.
Color legend for sensors:
Rita Sevastjanova, University of Konstanz, Germany, rita.sevastjanova@uni-konstanz.de
Phi-Vu Ly, University of Konstanz, Germany, phi.ly@uni-konstanz.de
The choro visualization aims at displaying patterns and anomalies of static proximity card data for employees. For that purpose we subdivide the design space into 3 sections, representing the different floors of the building. Each of the section is divided into equal-sized subitems, providing the information about hourly windows within the two weeks. Within those we color-encode the frequency of recorded proximity cards in the respective zones. The domain of recorded instances can be reduced by applying filters for institutional-departments. By selecting a single proximity polygon, the employees being active can be displayed.
As we identified spatial precision increasingly relevant with respect to mobile proximity data, we reference the latter in a more detailed and precise interface. There the frequency of the recorded proximity cards is mapped to the size and transparency of the dots. In addition, we provide further filter opportunities and navigational patterns.
We achieve the linkage between positional and energetic data, by displaying the latter in a visually comparable UI. Using a circular glyph layout we ilustrate the variances of the energetic sensor data between intervals of 5 minutes. The glyphs are divided into four specifically colored groups, representing the temperature, air flow, energy consumption and remaining information, like CO2 concentration and damper settings.
To gain an overview for the entire temporal range, we provide a spiral-view visualization. One spiral ilustrates data either for one energy zone, floor or the whole building on a specific day. The temporal domain of 24 hours is encoded onto the circle segments radii, using binnings of 5 minutes. The spirals are arranged according to topological and temporal aspects.
After having conducted few data transformation and preprocessing steps, we were able to integrate each (i.e. movement, energetic and miscellaneous) type of data into our system of linked and complementing visualizations. Our visualization layer can be subdivided by naming two categories. We relate to views which provide an overview for the entire temporal range, aiming to the detection of global patterns. Thus, we observed tabularised choropleths and our spiral glyph visualization as well apllicable approaches. In addition, we provide visualizations where we set our focus rather on spatial and temporal precision. By combining both visualization types,local patterns and anomalies can be well detected- especially at the overview- and analyzed - especially on the focus level. Regarding our interaction layer, we integrated rich filtering opportunities, by which comparisons between settings can be conducted. Furthermore, details-on-demand approaches are included, as various information (concrete sensor measurements, accumulations of positional information, etc.) gets displayed by clicking or hovering elements.
2. Shortly before 12PM employees start to leave the building (lunch time), and after 12PM they are returning to their offices again. The flow of staff members indicates to it - on the floor 1 no offices are located, therefore increased level of prox records on floor 1 could mean that employees are entering or leaving the building.
3. In the evenings some staff members are still working. (facilities, IT, G. Florez from administration (7.Juni 0AM), engineering).
4.Meetings of Engineering and IT Department between 2PM and 3PM around 2700 (lot of distinct employees having a significant distance to their common offices).
2. On the floor 1 and 2 - if the Thermostat Setpoints are changed (at 6AM), then one hour till 7AM for the BathExhaust: Fan Power, VAV SYS Outdoor Air Flow Fraction, VAV SYS Outdoor Air Mass Flow Rate (floor sensors) the values are 0. It also might indicate to problems existing in the VAV system.
3. Nobody visits left-sided wing of offices on second floor after 5PM.
4. No one from facility department visits left-sided wing on second floor within the two weeks. Exception: P. Young (10 AM bin, on 2 subsequent days) and C. Hawelon (every day on 3PM bin).
5. Averaged Movement Pattern Rosie:
1;"09:00:00" - "09:04:13"
2;"09:07:42" - "09:30:00"
3; "09:32:30" - "9:46:18"
Good-bye on floor 1: "09:54:46"
1; "14:00:00" - "14:04:20"
2; "14:08:06" - "14:26:30"
3; "14:33:30" - "14:46:12"
Good-bye on floor 1: 14:54:00
We observed first and last Rosie recordings We identified first and last movement detections from Rosie per floor and time-unit and averaged over 14 days.
6. Employees from Security Department have their central in 2710. Exceptional movement patterns occur with respect to the following employees: fresumir001 is the only one patroling on floor3. S. Fusil and V. Lagos are active in entry area (corridors and gates). In the morning, we expect a meetup for the security department in 2710.
7. Thermostat Heating Setpoints and Thermostat Cooling Setpoints differ for the day and night. The 'normal' settings (settings for the most of the days in most of the zones) for the day (6AM-22PM) Setpoints are approx. 21-24 degrees and in the night (22PM-6AM) approx. 16-26.
8. The daily energy consumption for most of the zones is quite similar. The energy is used at similar points of time and having similar duration.
9. In corridors lights are always switched on, even during night and weekends.
10. In Zone 9 (server) on the floor 3 the Thermostat Setpoints stays the same (except in the two days when the Setpoints of the whole building (except the Zone 1 on Floor 3) are set higher), very high energy consumption.
2. On the 2nd of June in the zone 1 on floor 3 Hazium is still in the air. The Thermostat Setpoints are set to 10 degrees, which means that the Damper is opened, the Supply Inlet Mass Flow Rate is increased and the air circulation is provided. Beginning with that point of time the Hazium concentration on the floor 2 starts to increase. In the beginning of the work day after the Dampers on the floor 2 are opened, the value of the Hazium increases even more. Shortly after 1PM on the floor 3 in zone 1 the Setpoints are set much higher again, which means that the Dampers are closed, Reheat Coil Power increases. That means, that no air circulation is provided, the value of Hazium in this zone increases. Interesting is that such kind of pattern (very low and very high Thermostat Settings for the zone 1 on floor 3) remains for the rest of the 13 days.
3. In the whole building on the 7th and 8th of June (Wednesday and Thursday), all the Setpoits are set really high (even in the Server zone, where the settings have never been changed) during day and low during night. Only the zone 1 on floor 3 remains with its specific settings. Could it mean that the zone 1 on floor 3 is some specific zone, where some restrictions exist - maybe one is not able to change settings for the whole building including the zone 1?
4. On the weekends some employees (Administration: lcarrara001, mbramar001, llagos001) are taking the elevator to the floor 3 and visiting diverse zones (including the zone 1 where the Hazium Sensor is located).
5. On the floor 2 where 2 Hazium sensors are located, both of the sensors have similar values in the same points of time. That might mean, that the Hazium is distributed with the Air Supply System.
6. Missing proximity data/cards per department: Security 10/21 (47.6%) , Admins 1/15 (6.6%), Engineering 1/34(2.9%), Executive 3/10(33.3%), IT 1/18 (5.5%), Facilities 3/24 (12.5%), HR 0/3. We found this out after simply querying our database. Probably the security members are leaving their cards on the floor 2 and walking around without any prox card.
7. On the floor 1 in zone 2: two times the Setpoints are being changed to much higher temperature (only in this single zone). It happens on the 1st of June (Wednesday) and on the 10th of June (Friday). Strange is the fact, that in that zone no specific energy or lights power consumption is visible (which could mean, that no one is working in this zone). Why to change the Setpoints then?
8. Only two mobile prox records for administrators on second floor, concentrated on third floor. Similar for Executive Department- and only one registered security there?
9. Geneviere Florez (Administration) possesses the most prox cards (common:1-2, she: gflorez00[2,5]). We found this out after simply querying our database. What's about gflorez001? Maybe lost?
10. On the floor 3 in Zone 1 there is not a similar daily energy usage. The time and duration changes for different days.
2. On the weekends some staff members (L.Carrara(001)-Administration, O.Strum(001)-Executive, M.Bramar(001)-Administration, L.Lagos(001)-Administration) are in the zone 1, but no energy or lights power is used. Do they want to stay unrecognized?
3. On the 9th of June (Thursday) on Floor 3 all Setpoints are changed to very low temperature, only in zone 8 the settings are changed to high temperature which means, that the dampers are closed. In this zone might be the I.Lagos(001), P.Beebe(001), P.Young(002)
4. When the first time on the floor 3 in zone 1 the Thermostat Setpoints are changed (7AM), 4 persons are recorded in the zone: L.Carrara(001)-Administration, , M.Bramar(001)-Administration, L.Lagos(001)-Administration, L.Fresumir(001)-Security. At 3PM when the Setpoints are set much higher, no person is recorded in this zone. It might indicate, that at 7AM already the settings for the following time-period (following 13 days) have been set.
5. Shortly before the Hazium value increases on the floor 3 (on the 1st of June), in two other zones (5 and 6) are changed the Thermostat Setpoints. No prox cards are recorded in these zones at this point of time. But following persons are registered in the corridor: C.Lair, C.Solos, M.Bramar.
Color legend for sensors: